-- 字典类型信息
-- set @dictId=100;
insert all
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 1,'用户性别','sys_user_sex','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'用户性别','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 2,'菜单状态','sys_show_hide','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'菜单状态','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 3,'系统开关','sys_normal_disable','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'系统开关','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 4,'系统是否','sys_yes_no','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'系统是否','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 5,'操作类型','sys_oper_type','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'操作类型','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 6,'系统状态','sys_success_fail','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'系统状态','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 7,'用户状态','sys_user_status','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'用户状态','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 8,'公司列表','sys_company','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'公司列表','select company_id,parent_id,ancestors,company_name,company_code,company_shortname,company_type,company_level,address,postcode,phone,fax,leader,email,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8 from sys_company where status=''Y'' and del_flag=''N'' order by order_num','Y')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 9,'部门列表','sys_dept','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'部门列表','select dept_id,company_id,parent_id,ancestors,dept_name,dept_code,dept_shortname,dept_type,dept_level,address,postcode,phone,fax,leader,email,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8 from sys_dept where status=''Y'' and del_flag=''N'' order by order_num','Y')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 10,'数据权限范围','sys_data_scope','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'数据权限范围','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 11,'公司类型','sys_company_type','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'公司类型','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 12,'公司级别','sys_company_level','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'公司级别','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 13,'部门类型','sys_dept_type','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'部门类型','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 14,'部门级别','sys_dept_level','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'部门级别','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 15,'公告类型','sys_notice_type','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'公告类型','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 16,'系统缓存类型列表','sys_cache_type','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'系统缓存类型列表','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 17,'应用系统标识','sys_app_key','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'应用系统标识','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 18,'菜单分组','sys_menu_group','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'菜单分组','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 19,'智码系统⽤户信息','code_sys_user_info','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'智码系统⽤户信息','','N')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 20,'MDA模型数据','mda_table_info_list','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'MDA模型数据','SELECT table_name AS DICT_VALUE,description AS DICT_LABEL FROM mda_table_info WHERE is_enable = ''Y''','Y')
into sys_dict_type (dict_id,dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark,view_sql,sql_mode_on) values
(100 + 21,'流程部署信息','code_wf_deployment_list','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'流程部署信息','SELECT key_ AS DICT_VALUE,name_ AS DICT_LABEL FROM act_re_model WHERE	deployment_id_ IN (SELECT id_ FROM act_re_deployment WHERE deploy_time_ IS NOT NULL)','Y')
SELECT * from dual;

-- 字典值集数据
-- set @dictCode=100;
insert all
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 1,1,'男','0','sys_user_sex','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 2,2,'女','1','sys_user_sex','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 3,3,'未知','2','sys_user_sex','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 4,1,'显示','Y','sys_show_hide','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 5,2,'隐藏','N','sys_show_hide','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 6,1,'正常','Y','sys_normal_disable','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 7,2,'停用','N','sys_normal_disable','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 8,1,'是','Y','sys_yes_no','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 9,2,'否','N','sys_yes_no','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 10,1,'新增','1','sys_oper_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 11,2,'修改','2','sys_oper_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 12,3,'删除','3','sys_oper_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 13,4,'授权','4','sys_oper_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 14,5,'导出','5','sys_oper_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 15,6,'导入','6','sys_oper_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 16,7,'强退','7','sys_oper_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 17,8,'生成代码','8','sys_oper_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 18,9,'清空数据','9','sys_oper_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 19,1,'成功','Y','sys_success_fail','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 20,2,'失败','N','sys_success_fail','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 21,1,'正常','0','sys_user_status','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 22,2,'禁用','1','sys_user_status','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 23,3,'锁定','2','sys_user_status','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 24,10,'全部数据权限','01','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 25,20,'指定公司数据权限','02','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 26,30,'指定部门数据权限','03','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 27,40,'仅本公司数据权限','04','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 28,50,'本公司及以下数据权限','05','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 29,60,'仅本部门数据权限','06','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 30,70,'本部门及以下数据权限','07','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 31,80,'仅本人数据权限','08','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 32,90,'仅上级公司权限','09','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 33,100,'上级公司及以下权限','10','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 34,110,'仅上级部门权限','11','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 35,120,'上级部门及以下权限','12','sys_data_scope','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 36,1,'上市公司','0','sys_company_type','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 37,2,'存续公司','2','sys_company_type','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 38,1,'集团公司','0','sys_company_level','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 39,2,'省公司','1','sys_company_level','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 40,3,'市公司','2','sys_company_level','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 41,4,'县公司','3','sys_company_level','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 42,1,'管理部门','0','sys_dept_type','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 43,2,'经营部门','1','sys_dept_type','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 44,1,'一级部门','0','sys_dept_level','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 45,2,'二级部门','1','sys_dept_level','','','Y','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 46,1,'通知','1','sys_notice_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 47,1,'公告','2','sys_notice_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 48,1,'定时任务缓存示例','zbiti:job:','sys_cache_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 49,2,'MDA缓存示例','zbiti:mda:','sys_cache_type','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 50,1,'默认应用','anvil-common','sys_app_key','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 51,1,'用户ID','userId','code_sys_user_info','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 52,3,'用户名称','userName','code_sys_user_info','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 53,3,'登录名','loginName','code_sys_user_info','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 54,4,'⼿机号','phone','code_sys_user_info','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 55,5,'公司ID','companyId','code_sys_user_info','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 56,6,'公司名称','companyName','code_sys_user_info','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 57,7,'公司编码','companyCode','code_sys_user_info','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 58,8,'部门ID','deptId','code_sys_user_info','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 59,9,'部门名称','deptName','code_sys_user_info','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
into sys_dict_data (dict_code,dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100 + 60,10,'部门编码','deptCode','code_sys_user_info','','','N','Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','','')
SELECT * from dual;

-- 初始化公司信息
insert all
into sys_company (company_id,parent_id,ancestors,company_name,company_code,company_shortname,company_type,company_level,address,postcode,phone,fax,order_num,leader,email,status,del_flag,create_by,create_time,update_by,update_time,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100,0,'0','Anvil集团','A01','Anvil集团','0','0','','','','',1,'','','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','')
into sys_company (company_id,parent_id,ancestors,company_name,company_code,company_shortname,company_type,company_level,address,postcode,phone,fax,order_num,leader,email,status,del_flag,create_by,create_time,update_by,update_time,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(101,100,'0,100','Anvil江苏分公司','A0101','江苏分公司','0','1','','','','',1,'','','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','')
into sys_company (company_id,parent_id,ancestors,company_name,company_code,company_shortname,company_type,company_level,address,postcode,phone,fax,order_num,leader,email,status,del_flag,create_by,create_time,update_by,update_time,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(102,100,'0,100','Anvil浙江分公司','A0102','浙江分公司','0','1','','','','',2,'','','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','')
into sys_company (company_id,parent_id,ancestors,company_name,company_code,company_shortname,company_type,company_level,address,postcode,phone,fax,order_num,leader,email,status,del_flag,create_by,create_time,update_by,update_time,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(1011,101,'0,100,101','Anvil南京分公司','A010101','Anvil南京分公司','0','2','','','','',1,'','','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','')
SELECT * from dual;

-- 初始化部门信息
insert all
into sys_dept (dept_id,company_id,parent_id,ancestors,dept_name,dept_code,dept_shortname,dept_type,dept_level,address,postcode,phone,fax,order_num,leader,email,status,del_flag,create_by,create_time,update_by,update_time,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(100,101,0,'0','研发部','D01','研发部','1','1','','','','',1,'','','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','')
into sys_dept (dept_id,company_id,parent_id,ancestors,dept_name,dept_code,dept_shortname,dept_type,dept_level,address,postcode,phone,fax,order_num,leader,email,status,del_flag,create_by,create_time,update_by,update_time,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(101,101,100,'0,100','研发一部','D0101','研发一部','1','1','','','','',1,'','','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','')
into sys_dept (dept_id,company_id,parent_id,ancestors,dept_name,dept_code,dept_shortname,dept_type,dept_level,address,postcode,phone,fax,order_num,leader,email,status,del_flag,create_by,create_time,update_by,update_time,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(102,101,100,'0,100','研发二部','D0102','研发二部','1','1','','','','',1,'','','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','')
into sys_dept (dept_id,company_id,parent_id,ancestors,dept_name,dept_code,dept_shortname,dept_type,dept_level,address,postcode,phone,fax,order_num,leader,email,status,del_flag,create_by,create_time,update_by,update_time,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(103,1011,0,'0','咨询部','D0102','咨询部','1','1','','','','',1,'','','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','','','','','')
SELECT * from dual;

-- 岗位信息表
insert all
into sys_post (post_id,post_code,post_name,post_sort,status,create_by,create_time,update_by,update_time,remark) values
(1,'CEO','董事长',1,'Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'')
into sys_post (post_id,post_code,post_name,post_sort,status,create_by,create_time,update_by,update_time,remark) values
(2,'PM','项目经理',2,'Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'')
into sys_post (post_id,post_code,post_name,post_sort,status,create_by,create_time,update_by,update_time,remark) values
(3,'HR','人力资源',3,'Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'')
into sys_post (post_id,post_code,post_name,post_sort,status,create_by,create_time,update_by,update_time,remark) values
(4,'EMPLOYEE','普通员工',4,'Y','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'')
SELECT * from dual;

-- 角色信息表
insert all
into sys_role (role_id,role_name,role_key,role_type,role_sort,data_scope,status,del_flag,create_by,create_time,update_by,update_time,remark) values
(10,'超级管理员','anvil',0,10,'01','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'管理员')
into sys_role (role_id,role_name,role_key,role_type,role_sort,data_scope,status,del_flag,create_by,create_time,update_by,update_time,remark) values
(20,'配置管理员','configAnvil',1,20,'08','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'配置管理员')
into sys_role (role_id,role_name,role_key,role_type,role_sort,data_scope,status,del_flag,create_by,create_time,update_by,update_time,remark) values
(30,'公司负责人','companyAnvil',2,30,'05','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'公司负责人')
into sys_role (role_id,role_name,role_key,role_type,role_sort,data_scope,status,del_flag,create_by,create_time,update_by,update_time,remark) values
(40,'公司经理','companyManager',2,40,'04','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'公司经理')
into sys_role (role_id,role_name,role_key,role_type,role_sort,data_scope,status,del_flag,create_by,create_time,update_by,update_time,remark) values
(50,'公司员工','companyUser',2,50,'08','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'公司员工')
into sys_role (role_id,role_name,role_key,role_type,role_sort,data_scope,status,del_flag,create_by,create_time,update_by,update_time,remark) values
(60,'部门负责人','deptAnvil',2,60,'07','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'部门负责人')
into sys_role (role_id,role_name,role_key,role_type,role_sort,data_scope,status,del_flag,create_by,create_time,update_by,update_time,remark) values
(70,'部门经理','deptManager',2,70,'06','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'部门经理')
into sys_role (role_id,role_name,role_key,role_type,role_sort,data_scope,status,del_flag,create_by,create_time,update_by,update_time,remark) values
(80,'部门员工','deptUser',2,80,'08','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'部门员工')
into sys_role (role_id,role_name,role_key,role_type,role_sort,data_scope,status,del_flag,create_by,create_time,update_by,update_time,remark) values
(90,'自定义公司','customCompany',2,90,'02','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'自定义公司')
into sys_role (role_id,role_name,role_key,role_type,role_sort,data_scope,status,del_flag,create_by,create_time,update_by,update_time,remark) values
(100,'自定义部门','customDept',2,100,'03','Y','N','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'自定义部门')
SELECT * from dual;

-- 用户信息表
insert all
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(1,'anvil',100,0,'系统管理员','0','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(2,'config_anvil',100,0,'配置管理员','1','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(3,'js_anvil',101,0,'江苏公司负责人','2','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(4,'js_manager',101,0,'江苏公司经理','2','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(5,'js_user',101,0,'江苏公司员工','2','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(6,'yfb_anvil',101,100,'研发部负责人','2','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(7,'yfb_manager',101,100,'研发部部门经理','2','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(8,'yfb_user',101,100,'研发部员工','2','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(9,'zxb_anvil',1011,103,'咨询部负责人','2','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(10,'zj_user1',102,0,'浙江员工A','2','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(11,'zj_user2',102,0,'浙江员工B','2','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(12,'yfb1_user',101,101,'研发一部员工','2','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
into sys_user (user_id,login_name,company_id,dept_id,user_name,user_type,email,phonenumber,sex,avatar,password,salt,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,emp_code,emp_idcard,nation,birthday,tel,tel2,oldpwds,dynamicpwd,dynamic_serial,mobile_login,must_update_pwd,update_pwd_time,retry_pwd_count,lock_start_time,lock_end_time,portal_user_id,wx_open_id,extcol1,extcol2,extcol3,extcol4,extcol5,extcol6,extcol7,extcol8) values
(13,'yfb2_user',101,102,'研发二部员工','2','','','0','','$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy','f77e84','0','N','',NULL,'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'','','','',NULL,'','','','','','','N',NULL,0,NULL,NULL,'','','','','','','','','','')
SELECT * from dual;

-- 用户角色表
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 1, 10);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 2, 20);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 3, 30);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 4, 40);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 5, 50);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 6, 60);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 7, 70);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 8, 80);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 9, 60);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 10, 90);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 11, 100);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 12, 80);
insert into sys_user_role (id, user_id, role_id) values (SEQ_SYS_USER_ROLE.NEXTVAL, 13, 80);

-- 菜单信息表(示例程序：100~199)
-- 执行anvil.postgres.sample.sql脚本

-- 菜单信息表(待办系统：200~299)
insert all
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(700,'系统管理',0,700,'System','','N','#','M','Y','Y','','system','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'系统管理')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(701,'用户管理',700,10,'SystemUser','@base/user/index','N','/system/user','C','Y','Y','system:user:view','user','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'用户管理')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(702,'角色管理',700,20,'SystemRole','@base/role/index','N','/system/role','C','Y','Y','system:role:view','peoples','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'角色管理')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(703,'公司管理',700,30,'SystemCompany','@base/company/index','N','/system/company','C','Y','Y','system:company:view','tree','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'公司管理')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(704,'部门管理',700,40,'SystemDept','@base/dept/index','N','/system/dept','C','Y','Y','system:dept:view','tree','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'部门管理')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(705,'岗位管理',700,50,'SystemPost','@base/post/index','N','/system/post','C','Y','Y','system:post:view','tree','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'岗位管理')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(706,'菜单管理',700,60,'SystemMenu','@base/menu/index','N','/system/menu','C','Y','Y','system:menu:view','tree','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'菜单管理')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(707,'字典管理',700,70,'SystemDict','@base/dict/index','N','/system/dict','C','Y','Y','system:dict:view','dict','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'字典管理')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(708,'参数设置',700,80,'SystemConfig','@base/config/index','N','/system/config','C','Y','Y','system:config:view','edit','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'参数设置')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(710,'ZCache管理',700,100,'SystemCache','@base/cache/index','N','/system/cache','C','Y','Y','system:cache:view','system','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'ZCache管理')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(712,'MDA仓储管理',700,110,'SystemMDA','@base/mda/index','N','/system/mda','C', 'Y', 'Y','system:mda:view','redis','init', TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'), 'init', TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'), 'MDA仓储管理')
SELECT * from dual;

-- 菜单按钮
insert all
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 0,'查询',701,1,'','','N','#','F','Y','Y','system:user:search','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'用户查询')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 1,'新增',701,2,'','','N','#','F','Y','Y','system:user:insert','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'用户新增')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 2,'修改',701,3,'','','N','#','F','Y','Y','system:user:update','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'用户修改')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 3,'删除',701,4,'','','N','#','F','Y','Y','system:user:delete','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'用户删除')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 4,'导出',701,5,'','','N','#','F','Y','Y','system:user:export','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'用户导出')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 5,'导入',701,6,'','','N','#','F','Y','Y','system:user:import','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'用户导入')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 6,'重置密码',701,7,'','','N','#','F','Y','Y','system:user:resetPwd','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'重置密码')

into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 7,'查询',702,1,'','','N','#','F','Y','Y','system:role:search','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'角色查询')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 8,'新增',702,2,'','','N','#','F','Y','Y','system:role:insert','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'角色新增')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 9,'修改',702,3,'','','N','#','F','Y','Y','system:role:update','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'角色修改')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 10,'删除',702,4,'','','N','#','F','Y','Y','system:role:delete','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'角色删除')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 11,'导出',702,5,'','','N','#','F','Y','Y','system:role:export','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'角色导出')

into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 12,'查询',703,1,'','','N','#','F','Y','Y','system:company:search','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'菜单查询')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 13,'新增',703,2,'','','N','#','F','Y','Y','system:company:insert','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'菜单新增')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 14,'修改',703,3,'','','N','#','F','Y','Y','system:company:update','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'菜单修改')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 15,'删除',703,4,'','','N','#','F','Y','Y','system:company:delete','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'菜单删除')

into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 16,'查询',704,1,'','','N','#','F','Y','Y','system:dept:search','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'部门查询')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 17,'新增',704,2,'','','N','#','F','Y','Y','system:dept:insert','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'部门新增')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 18,'修改',704,3,'','','N','#','F','Y','Y','system:dept:update','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'部门修改')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 19,'删除',704,4,'','','N','#','F','Y','Y','system:dept:delete','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'部门删除')

into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 20,'查询',705,1,'','','N','#','F','Y','Y','system:post:search','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'岗位查询')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 21,'新增',705,2,'','','N','#','F','Y','Y','system:post:insert','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'岗位新增')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 22,'修改',705,3,'','','N','#','F','Y','Y','system:post:update','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'岗位修改')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 23,'删除',705,4,'','','N','#','F','Y','Y','system:post:delete','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'岗位删除')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 24,'导出',705,5,'','','N','#','F','Y','Y','system:post:export','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'岗位导出')

into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 25,'查询',706,1,'','','N','#','F','Y','Y','system:menu:search','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'菜单查询')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 26,'新增',706,2,'','','N','#','F','Y','Y','system:menu:insert','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'菜单新增')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 27,'修改',706,3,'','','N','#','F','Y','Y','system:menu:update','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'菜单修改')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 28,'删除',706,4,'','','N','#','F','Y','Y','system:menu:delete','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'菜单删除')

into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 29,'查询',707,1,'','','N','#','F','Y','Y','system:dict:search','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'字典查询')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 30,'新增',707,2,'','','N','#','F','Y','Y','system:dict:insert','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'字典新增')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 31,'修改',707,3,'','','N','#','F','Y','Y','system:dict:update','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'字典修改')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 32,'删除',707,4,'','','N','#','F','Y','Y','system:dict:delete','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'字典删除')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 33,'导出',707,5,'','','N','#','F','Y','Y','system:dict:export','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'字典导出')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 34,'清理缓存',707,6,'','','N','#','F','Y','Y','system:dict:clear','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'清理缓存')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 35,'数据查询',707,7,'','','N','#','F','Y','Y','system:dict:data:search','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'字典查询')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 36,'数据新增',707,8,'','','N','#','F','Y','Y','system:dict:data:insert','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'字典新增')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 37,'数据修改',707,9,'','','N','#','F','Y','Y','system:dict:data:update','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'字典修改')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 38,'数据删除',707,10,'','','N','#','F','Y','Y','system:dict:data:delete','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'字典删除')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 39,'数据导出',707,11,'','','N','#','F','Y','Y','system:dict:data:export','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'字典导出')

into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 40,'查询',708,1,'','','N','#','F','Y','Y','system:config:search','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'参数查询')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 41,'新增',708,2,'','','N','#','F','Y','Y','system:config:insert','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'参数新增')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 42,'修改',708,3,'','','N','#','F','Y','Y','system:config:update','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'参数修改')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 43,'删除',708,4,'','','N','#','F','Y','Y','system:config:delete','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'参数删除')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 44,'导出',708,5,'','','N','#','F','Y','Y','system:config:export','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'参数导出')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 45,'清理缓存',708,6,'','','N','#','F','Y','Y','system:config:clear','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'清理缓存')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 50,'查询',710,1,'','','N','#','F','Y','Y','system:cache:search','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'缓存查询')
into sys_menu (menu_id,menu_name,parent_id,order_num,path,component,is_frame,url,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values
(70000 + 51,'删除',710,2,'','','N','#','F','Y','Y','system:cache:delete','#','init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'init',TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'),'缓存删除')
SELECT * from dual;

-- 设置角色菜单
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 20 as role_id , menu_id from	sys_menu where menu_id in (700, 702, 706, 707, 708, 710);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 30 as role_id , menu_id from	sys_menu where menu_id in (200, 700, 701, 703, 704)	or parent_id in (200);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 40 as role_id , menu_id from	sys_menu where menu_id in (200, 700, 701, 703, 704)	or parent_id in (200);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 50 as role_id , menu_id from	sys_menu where menu_id in (200, 700, 701, 703, 704)	or parent_id in (200);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 60 as role_id , menu_id from	sys_menu where menu_id in (200, 700, 701, 703, 704)	or parent_id in (200);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 70 as role_id , menu_id from	sys_menu where menu_id in (200, 700, 701, 703, 704)	or parent_id in (200);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 80 as role_id , menu_id from	sys_menu where menu_id in (200, 700, 701, 703, 704)	or parent_id in (200);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 900 as role_id , menu_id from	sys_menu where menu_id in (200, 700, 701, 703, 704)	or parent_id in (200);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 100 as role_id , menu_id from	sys_menu where menu_id in (200, 700, 701, 703, 704)	or parent_id in (200);
-- 设置角色按钮
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 20 as role_id , menu_id from	sys_menu where menu_type = 'F' and parent_id in (select menu_id from sys_role_menu where role_id = 20);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 30 as role_id , menu_id from	sys_menu where menu_type = 'F' and parent_id in (select menu_id from sys_role_menu where role_id = 30);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 40 as role_id , menu_id from	sys_menu where menu_type = 'F' and parent_id in (select menu_id from sys_role_menu where role_id = 40);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 50 as role_id , menu_id from	sys_menu where menu_type = 'F' and parent_id in (select menu_id from sys_role_menu where role_id = 50);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 60 as role_id , menu_id from	sys_menu where menu_type = 'F' and parent_id in (select menu_id from sys_role_menu where role_id = 60);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 70 as role_id , menu_id from	sys_menu where menu_type = 'F' and parent_id in (select menu_id from sys_role_menu where role_id = 70);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 80 as role_id , menu_id from	sys_menu where menu_type = 'F' and parent_id in (select menu_id from sys_role_menu where role_id = 80);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 90 as role_id , menu_id from	sys_menu where menu_type = 'F' and parent_id in (select menu_id from sys_role_menu where role_id = 90);
insert into sys_role_menu (id, role_id, menu_id) select seq_sys_role_menu.nextval as id, 100 as role_id , menu_id from	sys_menu where menu_type = 'F' and parent_id in (select menu_id from sys_role_menu where role_id = 100);

insert into sys_role_data_scope (id, role_id, company_id, dept_id) values (seq_sys_role_data_scope.nextval, 90, 1011, null);
insert into sys_role_data_scope (id, role_id, company_id, dept_id) values (seq_sys_role_data_scope.nextval, 100, null, 101);
insert into sys_role_data_scope (id, role_id, company_id, dept_id) values (seq_sys_role_data_scope.nextval, 100, null, 102);

-- 设置默认的OAuth客户端
INSERT INTO sys_oauth_client VALUES ('web', '', '$2a$10$s260QACZGOrhR5XF1gCzq.Wl4OsWYpfNJEdV6AIPte4WhrDVenhsy', 'all', 'password,refresh_token', NULL, NULL, 3600, 7200, NULL, 'Y', 'N', 'init', TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'), 'init', TO_TIMESTAMP('2024-01-02 03:04:05', 'YYYY-MM-DD HH24:MI:SS'), NULL);